"Copying" Jobs from one server to another

[Joe]

Hello -
I was curious if there is any way to "copy" a SQL Job, alert etc. from one server to another. I want to test jobs on a non production server before putting them out on our live Server. I understand you can do the whole Master server thing, but this temp server is often rebuilt for whatever we need.
Any insights would be greatly appreciated...
Thanks in Advance.
Joe

[Marc ISRAEL]

Joe, you can script your jobs out (right click on the job All tasks, generate script to script the job, or right click in the jobs list right pane and generate all scripts...) then you run this or these scripts on your production box and on it goes...


------------
Joe at 8/26/99 4:23:37 PM


Hello -
I was curious if there is any way to "copy" a SQL Job, alert etc. from one server to another. I want to test jobs on a non production server before putting them out on our live Server. I understand you can do the whole Master server thing, but this temp server is often rebuilt for whatever we need.
Any insights would be greatly appreciated...
Thanks in Advance.
Joe